package org.nicholasjones.radiocontroller.web.data.patches;

import org.brownflat.dbinit.upgrade.Upgrade;
import org.brownflat.dbinit.upgrade.UpgradeStatement;

import java.util.ArrayList;
import java.util.List;

public class Upgrade001 implements Upgrade {
    @Override
    public int getSequence() {
        return 1;
    }

    @Override
    public List<UpgradeStatement> getSql() {
        List<UpgradeStatement> statements = new ArrayList<UpgradeStatement>();
        UpgradeStatement statementOne = new UpgradeStatement("CREATE TABLE CONFIGURATION (KEY VARCHAR(255), CONFIG_VALUE VARCHAR(255));COMMIT;");
        statements.add(statementOne);
        return statements;
    }

    @Override
    public String getName() {
        return "Create Configuration Table";
    }
}
